UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VzZzeWrjO0lMAwegX8P9F3n1naVwwPzu8vMju+zut+s='
WHERE
key_id = 'a59e06f14cecd61ac24633c93bd2177bb80b86baa055f60cb63bc0d5ba9486ab'
AND (
token = 'VzZzeWrjO0lMAwegX8P9F3n1naVwwPzu8vMju+zut+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)