UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XWrhakYPtc0aWyYPmjfn5TtximJM9XTDDY882Fepa4g='
WHERE
key_id = '3e9afb0bf1880b2abdabfc64cbe8c26e433690d81a2af4a52a4d40907176da2e'
AND (
token = 'XWrhakYPtc0aWyYPmjfn5TtximJM9XTDDY882Fepa4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)