UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xGdy2w4eh96YDt8415jL2STo6ANcHAoCJgIJSbZZxjg='
WHERE
key_id = 'fbdf47b290e407f40548771073ef28b229093747003087c67b67dbeeb1c1a34f'
AND (
token = 'xGdy2w4eh96YDt8415jL2STo6ANcHAoCJgIJSbZZxjg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)