UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XEfLIO8XVr3NO4Zvffy1dV7+lIQGNbzvQlJPzQ30baA='
WHERE
key_id = 'd8a2e2f8c1b67a7ee13de3cd48a110816689cf1227199a9cf39873ad25f12fba'
AND (
token = 'XEfLIO8XVr3NO4Zvffy1dV7+lIQGNbzvQlJPzQ30baA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)