UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WZ1OnItVG11IavnD61f+KTfdBvM9l6rzom13J0yn/Ag='
WHERE
key_id = 'a29fc20d489a861e3684d61b0e53a0bdd67eb19bfd1bd89b00c84c367916bbc5'
AND (
token = 'WZ1OnItVG11IavnD61f+KTfdBvM9l6rzom13J0yn/Ag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)