UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kN5QhWWfdaBB66pYGb8lRJRWVD2DjcxfJXQDDtv/Gyk='
WHERE
key_id = '39168a48ee2c8fd33ef84d2d13b03a600727926d798f307eda215dd114751ac5'
AND (
token = 'kN5QhWWfdaBB66pYGb8lRJRWVD2DjcxfJXQDDtv/Gyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)