UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1MpUGRloY4k4bSM0wskdQN/6URKXDrMsibBaI/1Vumo='
WHERE
key_id = '8d3ffc26fa4e06814e8d3e1c295aafc2e08f93e32c5f8b9cf86d5201bcde3a03'
AND (
token = '1MpUGRloY4k4bSM0wskdQN/6URKXDrMsibBaI/1Vumo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)