UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sN824qBBe/NJdXt6K+JaNxs8R+DpTmrV5h1Sedp2XkI='
WHERE
key_id = 'bcf214993eb97974849a4bb886c4ee8ddbf9e904773dcbd01ead4ad54971bb17'
AND (
token = 'sN824qBBe/NJdXt6K+JaNxs8R+DpTmrV5h1Sedp2XkI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)