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