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