UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Sd1x4/D+8EMkUiNFkvHJKnzNAi/juDC6d+adCEQn/yc='
WHERE
key_id = 'a8a43905d0fc190ebcad04f846fe176794e2a0d563507e80fb0417c782c65cbd'
AND (
token = 'Sd1x4/D+8EMkUiNFkvHJKnzNAi/juDC6d+adCEQn/yc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)