UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mH1YuC3GcR14qdG1JEwDkyyNkdox4f7HKoOBL0E1crs='
WHERE
key_id = '2246923a59d9e3e82606cd04671cc79e07e6eab80825ee6387eb90beba4539f5'
AND (
token = 'mH1YuC3GcR14qdG1JEwDkyyNkdox4f7HKoOBL0E1crs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)