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