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