UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jJJlVCS0woLexsf6Ie0H1+j+6+xpmBdFA7BFx0gOXk8='
WHERE
key_id = 'e5739b4b425a3fb84f87a93228ac6f11db1a219457e93aa0c3daf5fc16cbae78'
AND (
token = 'jJJlVCS0woLexsf6Ie0H1+j+6+xpmBdFA7BFx0gOXk8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)