UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GXElYp0QzChsL6OQT8ddwE+0xCPz/pLvkKBBT4SJbh0='
WHERE
key_id = 'e6853a0a9602cbfd004adbc4a59728ef5d2d11b48a5b160d1d88c06c09a72788'
AND (
token = 'GXElYp0QzChsL6OQT8ddwE+0xCPz/pLvkKBBT4SJbh0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)