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