UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1LjMq3+4RiCmtaKfb+WJNE28agJ3DRT09BuQVQkVX+k='
WHERE
key_id = 'fe93448568f423741f9888d9a24e3e087f0c91a6a1c1ff464b5595e4b3964bb1'
AND (
token = '1LjMq3+4RiCmtaKfb+WJNE28agJ3DRT09BuQVQkVX+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)