UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'et48IccvwK28l+ZAAddNyIfcPOrrY2j75n0gtzT70tU='
WHERE
key_id = '14bc81ad7fe8265f55e417752d91e6107e528e03e2ad14b6a281e8ecd5536bd4'
AND (
token = 'et48IccvwK28l+ZAAddNyIfcPOrrY2j75n0gtzT70tU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)