UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7L1xoYUqo4aL4F2iqeOr+Yo81LB0H7GEJ8ph1DgNHUI='
WHERE
key_id = 'e65b70f4672014c85a00882b60fa62341e250d3e7aabee72150c4504a50e641e'
AND (
token = '7L1xoYUqo4aL4F2iqeOr+Yo81LB0H7GEJ8ph1DgNHUI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)