UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W8nAy1ZvSKmFVpO75z59CjbUm963FmK3dPh2aCkEi40='
WHERE
key_id = '2fe24f69c412e678d18cb1cb5b9afffca1ce185872caf22ace3c149d448f150f'
AND (
token = 'W8nAy1ZvSKmFVpO75z59CjbUm963FmK3dPh2aCkEi40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)