UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SHTb34SLbeWoDAngYDjC6OfvfhxtifV9GYHuDEn4Z5E='
WHERE
key_id = '556b99a05297623dd36b807fa100a9dce1ad01a502d8e2a2f7bfdc3ad5105d0b'
AND (
token = 'SHTb34SLbeWoDAngYDjC6OfvfhxtifV9GYHuDEn4Z5E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)