UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NwBeDU1gc8ORJhIfPIC5twnEW7SU0Zg58FubcEanGJ4='
WHERE
key_id = '83049717f5e6d54893c6bb60c70487e0fe8b5606d1856a7ccf1576f97984a3ad'
AND (
token = 'NwBeDU1gc8ORJhIfPIC5twnEW7SU0Zg58FubcEanGJ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)