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