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