UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YcYbiIc2rQ7reV0XCR9jmUObh/zAM4iKC2foMjIB5KY='
WHERE
key_id = 'e6c92f5a3627147daf273e34e93024080eaa3dcfd8e495b0e7c81030f5f39eab'
AND (
token = 'YcYbiIc2rQ7reV0XCR9jmUObh/zAM4iKC2foMjIB5KY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)