UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WYW0uNaFYAOwr7FfOpyiG0y783QWpptdQXGok1QAzyQ='
WHERE
key_id = '9786471c0a721f4bfc5004585cc511a102f95aedfacb82cac0127bb6f1b46171'
AND (
token = 'WYW0uNaFYAOwr7FfOpyiG0y783QWpptdQXGok1QAzyQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)