UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c/OzoiBoppThYYrw46W6CGhoVg2Wh6U5WSXmj7WretA='
WHERE
key_id = '74e4cd331bc319339ca2095a3c14f9a15134575844678b43e2390d4d69ce7202'
AND (
token = 'c/OzoiBoppThYYrw46W6CGhoVg2Wh6U5WSXmj7WretA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)