UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Av0Ln24yu8AbYFFysh8axDVwFatogSKgKQa29GtfAw='
WHERE
key_id = '342db5c96c8a9f3d78dc484dc65c9e373058074be09f66c20805a95637ed2ef3'
AND (
token = '6Av0Ln24yu8AbYFFysh8axDVwFatogSKgKQa29GtfAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)