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