UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z5lXZ9/eH2+NACSE2D48AhBTNwPM4sFP8Mqgt6t+9Qs='
WHERE
key_id = '2de120df613218535700031373e04ed0a15b42d3bfe23d41b42d197dabe5e8c2'
AND (
token = 'z5lXZ9/eH2+NACSE2D48AhBTNwPM4sFP8Mqgt6t+9Qs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)