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