UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gB7KsO3kd+UrM1L9uZyOK+0+rVK+DGD4soEf/HC8dfU='
WHERE
key_id = '07d58024f6374a61de91e820684b21d4be96e2df2a43ee03eb76d3fe27d07f17'
AND (
token = 'gB7KsO3kd+UrM1L9uZyOK+0+rVK+DGD4soEf/HC8dfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)